﻿use master 
go
--create database bocdownload
go
use bocdownload
go
if exists(select * from sysobjects where id=object_id('BankTransaction'))
drop table BankTransaction
go
create table BankTransaction(
	BankTransactionId  int IDENTITY(1,1) NOT NULL,
	BankRefNo nvarchar(200) not null,
	PostDate datetime not null,
	ValueDate datetime not null,
	Description nvarchar(1000) not null,
	Amount decimal(10,2) not null,
	constraint BankTransaction_pk primary key (BankTransactionId),
	constraint BankRefNo_uq unique (BankRefNo))
go
